Description
Entity name
Entity number
À
Capital A, grave accent
Agrave;
#192;
Á
Capital A, acute accent
Aacute;
#193;
Â
Capital A, circumflex accent
Acirc;
#194;
Ã
Capital A, tilde
Atilde;
#195;
Ä
Capital A, umlaut mark
Auml;
#196;
Å
Capital A, ring
Aring;
#1
Description
Bytes
?
Uppercase AE diphthing
Á
Á
Uppercase A, acute accent
Â
?
Uppercase A, circumflex accent
À
À
Uppercase A, grave accent
Bytes
?
Uppercase A, ring
Bytes
?
Uppercase A, tilde
Ä
?
Uppercase A, dieresis or umlaut mark
C.
?
Uppercase C, cedilla
Bytes
D
Uppe
8859-1 Character Entities
ISO 8859-1 character entity
Result
Description
Entity name
Entity count
À
Capital a, grave accent
Agrave;
#192;
Á
Capital a, acute accent
Aacute;
#193;
Â
Capital a, circumflex accent
Acirc;
#194;
Bytes
Capital a, tilde
Atilde;
#195;
Ä
Capital a, umlaut mark
Auml;
#196;
Bytes
Capital a, ring
Ar
Auml;
Ä
Uppercase A, dieresis or umlaut mark
Ccedil;
C.
Uppercase C, cedilla
ETH;
Bytes
Uppercase Eth, Icelandic
Eacute;
É
Uppercase E, acute accent
Ecirc;
Bytes
Uppercase E, circumflex accent
Egrave;
?
Uppercase E, grave accent
Euml;
Bytes
Uppercase E, dieresis or umlaut mark
Iacute;
Describe
Æ
?
Uppercase AE diphthing
Á
á
Uppercase A, acute accent
Â
?
Uppercase A, circumflex accent
À
à
Uppercase A, grave accent
Å
?
Uppercase A, ring
Coal tar
?
Uppercase A, tilde
Ä
?
Uppercase A, dieresis or
Description
Entity name
Entity number
À
Capital A, grave accent
Agrave;
#192;
Á
Capital A, acute accent
Aacute;
#193;
Â
Capital A, circumflex accent
Acirc;
#194;
Ã
Capital A, tilde
Atilde;
#195;
Ä
Capital A, umlaut mark
Auml;
#196;
Å
Capital A, ring
Aring;
#1
P
Q --- lowercase Q small Q
R --- lower case R small R
S --- lower case s small s
T --- lowercase T small T
U --- lower case u small u
V v --- lower case v small v
W --- lower case W small W
X --- lowercase x small x
Y --- lowercase y small y
Z --- lowercase Z small Z
{--- Left curly brace on the left of braces
| --- Vertical line vertical bar
} --- Right curly brace on the right of the braces
~ ~ --- Tilde
--- Unused not used
Nbsp; space nonbreaking Space
? Explain iexcl; inverted exclamatio
} #125; -The right part of the curly brace curly brace ~ #126; -tilde- #127; -Unused #160 not used;nbsp;space nonbreaking space? #161;iexcl;inverted exclamation¢ #162;cent;The symbol of currency cent sign£ #163;pound;Sterling Mark Pound sterling¤ #164;curren;General currency sign¥ #165 of universal currency symbol;yen;yen logo Yen sign | #166;brvbar;Orbrkbar;Broken vertical Line broken vertical bar§ #167;sect;section No. sign¨ #168;uml;Ordie;variable tone symbol
Symbol Pound Sterling¤ #164; curren; General currency Symbol currency sign¥ #165; yen; Yen symbol Yen Sign| #166; brvbar; or brkbar; Broken vertical bar Broken vertical bar§ #167; sect; Section number, part sign¨ #168; uml; or die; Variable tone symbol umlaut? #169; copy; Copyright BannerA #170; ordf; Feminine ordinal? #171; laquo; Left angle quote, Guillemet left? #172; not not sign? #173; shy; Soft Hyphen? #174; reg; Registered trademark Mar
Symbol Pound Sterling¤ #164; curren; General currency Symbol currency sign¥ #165; yen; Yen symbol Yen Sign| #166; brvbar; or brkbar; Broken vertical bar Broken vertical bar§ #167; sect; Section number, part sign¨ #168; uml; or die; Variable tone symbol umlaut? #169; copy; Copyright BannerA #170; ordf; Feminine ordinal? #171; laquo; Left angle quote, Guillemet left? #172; not not sign? #173; shy; Soft Hyphen? #174; reg; Registered trademark Mar
Symbol Pound Sterling¤ #164; curren; General currency Symbol currency sign¥ #165; yen; Yen symbol Yen Sign| #166; brvbar; or brkbar; Broken vertical bar Broken vertical bar§ #167; sect; Section number, Part Sign¨ #168; uml; or die; Variable tone symbol umlaut? #169; copy; Copyright BannerA #170; ordf; Feminine ordinal? #171; laquo; Left Angle quote, Guillemet left? #172; not not sign? #173; shy; Soft Hyphen? #174; reg; Registered trademark Mar
vW #119; ---lowercase w Small wX #120; ---lowercase x Small xY #121; ---lowercase y Small yZ #122; ---lowercase z Small z{ #123; ---Curly brace left curly brace| #124; ---vertical vertical bar} #125; ---the right part of the curly brace. Curly Brace~ #126; ---tilde--- #127; ---not used unused #160; nbsp; Spaces nonbreaking Space? #161; iexcl; Inverted exclamation¢ #162; cent; Currency mark cent sign£ #163; pound; Sterling Symbol Pound Sterling¤ #164; curren; General currency Symbol curr
#106;-lowercase J small JK #107;-lowercase K small KL #108;-lower case l small lM #109;-lower case M small mN #110;-lowercase n small NO #111;-lowercase o Small oP #112;-lower case P Small PQ #113;-lowercase Q small QR #114;-lower case R small RS #115;-lower case s small sT #116;-lowercase T small TU #117;-lower case u small uV #118;-lower case v small vW #119;-lower case W small WX #120;-lowercase x small xY #121;-lowercase y small yZ #122;-lowercase Z small Z{ #123;-left sect
¢ #162; cent; Currency mark cent sign£ #163; pound; Sterling Symbol Pound Sterling¤ #164; curren; General currency Symbol currency sign¥ #165; yen; Yen symbol Yen Sign| #166; brvbar; or brkbar; Broken vertical bar Broken vertical bar§ #167; sect; Section number, part sign¨ #168; uml; or die; Variable tone symbol umlaut? #169; copy; Copyright BannerA #170; ordf; Feminine ordinal? #171; laquo; Left angle quote, Guillemet left? #172; not not sign?
exclamation¢ #162; cent; Currency mark cent sign£ #163; pound; Sterling Symbol Pound Sterling¤ #164; curren; General currency Symbol currency sign¥ #165; yen; Yen symbol Yen Sign| #166; brvbar; or brkbar; Broken vertical bar Broken vertical bar§ #167; sect; Section number, part sign¨ #168; uml; or die; Variable tone symbol umlaut? #169; copy; Copyright BannerA #170; ordf; Feminine ordinal? #171; laquo; Left angle quote, Guillemet left? #172; not
Suppose the column X in table T has these latin1 column values:
Muffler Müller MX Systems MySQL
Suppose you use the following statement to get the column value:
SELECT X FROM T ORDER BY X COLLATE collation_name;
The results of column values that use different proofing rules are sorted as follows:
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX系统 Müller Muffler Müller MX系统 MX系统 MySQL MySQL MySQL
This table shows examples of the effects of using different coll
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.